<%-- 
    Document   : edit_email_message
    Created on : Apr 13, 2012, 11:43:31 AM
    Author     : dhananjay
--%>

<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@page import="jobportal.Dbconn"%>
<%@include file="header.jsp" %>
<table width="100%" border="0" cellpadding="0" cellspacing="1" style="border: 1px solid rgb(169, 211, 225);" >
    <tr class="tablemainheading">
        <td height="21" colspan="2" class="bluebg"><strong>Edit Email Message </strong>
        </td>
    </tr>
    <form name="form1"  action="emailupdate.jsp" method="post">
        
        
        <tr>
            <%
                        try {
                            String id = "";
                            if (request.getParameter("emailid") != null) {
                                id = request.getParameter("emailid");
                            }
                            String page1="";
                            if (request.getParameter("page") != null) {
                                page1 = request.getParameter("page");

                            }
                            Connection con = Dbconn.getConn();
                            Statement st = con.createStatement();
                            ResultSet rs=st.executeQuery("select * from emailmessage where id='"+id+"'");
                            if(rs.next()){
            %>
            <td width="13%" height="31" valign="middle" class="normal"><strong>Email  Name </strong></td>
            <td width="87%" valign="middle"><strong><%=rs.getString("id")%></strong>
        <input type="hidden" name="id" value="<%=rs.getString("id")%>"></td>
        <input type="hidden" name="page1" value="<%=page1%>">
        </tr>
        <tr>
            <td width="13%" height="31" valign="middle" class="normal"><strong>Subject</strong></td>
            <td width="87%" align="left" valign="middle"><strong>
                    <input name="subject" type="text" id="subject" size="40" value="<%=rs.getString("subject")%>"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                " /></strong></td>
        </tr>

        <tr>
            <td valign="top" class="normal"><strong>Email  Details </strong></td>
            <td>
                <textarea cols="22" rows="10"  name="tarea" id="wysiwyg" class="textarea" style="width:500px; height:200px;">
                    <%=rs.getString("content")%>
                </textarea>

               
            </td>
             <%
                           } } catch (Exception e) {
                                out.println(e);
                            }
                %>
        </tr>
        <tr>
            <td class="normal">&nbsp;</td>
            <td>&nbsp;</td>
        </tr>
        <tr>
            <td class="normal">&nbsp;</td>
            <td><input name="Submit" type="submit" class="button2" value="Update Page"></td>
        </tr>
    </form>
        <tr>
                                        <td class="bluebg" >
                                            <span class="canhead" ><b>  <span class="tablebackground">
                                                        Hint :
                                                    </span></b></span>

                                        </td>
                                        <td height="22" align="left" valign="middle" class="bluebg">
                                            <span class="canhead">  <span class="tablebackground">
JobSeeker Name: %stuname%|Password: %password%|Company Name: %compname%| college Name: %cllgname%| Jobtitle:%jobtitle%| Reg no: %regno%| Verification Code:%vercode%
                                                    </span></span>
                                        </td>
                                    </tr>
</table>
<%@include file="footer.jsp" %>